package com.julian.warehouse.database;

/**
 * Created by Administrator on 2018/8/8.
 */

public  class GoodsTable {
    public static final String TBL_NAME = "GOODS";
    public static final String COL_ID = "ID";
    public static final String COL_GNAME = "GNAME";
    public static final String COL_CTIME = "CTIME";
    public static final String COL_PICURL = "PICURL";
    public static final String COL_COUNT = "COUNT";
    public static final String COL_DESCRIPTION = "DESCRIPTION";
    public static final String COL_PRICE = "PRICE";
    public static final String COL_COST = "COST";


    public static String getCreatGoodsTableSQL() {
        String sql = "CREATE TABLE IF NOT EXISTS "
                + TBL_NAME + "(" + COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
                + COL_GNAME + " VARCHAR(200),"
                + COL_CTIME + " VARCHAR(50),"
                + COL_PICURL + " VARCHAR(200),"
                + COL_COUNT + " INTEGER,"
                + COL_DESCRIPTION + " TEXT,"
                + COL_PRICE + " DOUBLE,"
                + COL_COST + " DOUBLE"
                + ")";
        return sql;
    }
}